package com.sys.gradepaysys.mapper;

import com.sys.gradepaysys.model.Clazz;
import com.sys.gradepaysys.model.Grade;
import com.sys.gradepaysys.model.Student;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

import java.util.List;
import java.util.Map;

public interface StudentMapper {
    Student selectStuList(@Param("username") String username);

    Integer save(Student student);

    List<Grade> selectGradeList();

    List<Clazz>selectClazzList(@Param("gid") String gid);

    List<Map<String,String>> getStuOneList(String sid);

    @Update("update student set password=#{password} where s_id=#{sid} ")
    Integer updatePwd(@Param("password") String password,@Param("sid") String sid);

    
    List<Clazz> selectClazzByGid(@Param("cid") String cid,@Param("gid") String gid,@Param("cName") String cName);


}
